Column Settings
[Back]
The Column Settings screen allows you to change the attributes of the columns when they are displayed on your form. For each selected column you may make it a Text Field, Text Area or Choice pull-down list.
The steps include:
- Double-click a column. The SQL Select field will show that column's name. If desired, you may build an ODBC-compliant SQL function for this column. You can also change its Field Type setting.
- For Text Fields, you may set the field size, choose whether or not to allow editing of field data, and change the color combinations.
- For a Text Area you can also change number of columns and rows that field should display.
- For a Choice list, first choose whether the values should come from those entered here or from a separate set of tables and columns.
- To use values entered here, simply type the displayed value and the actual value in the table.
- If database tables/columns are used, select the table where the list of values is to come from. Then select the field that contains the description of the value and lastly select the field that contains the actual value.
- If necessary, you may add a special SQL Where clause to control the data returned in the pull down.
Press the Reset button if you want to undo all your selections and changes. Once you have setup all your result parameters, press Accept.
[Back]